Overview
Brought to you by YData
Dataset statistics
| Number of variables | 12 |
|---|---|
| Number of observations | 64104 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 17.7 MiB |
| Average record size in memory | 290.1 B |
Variable types
| Text | 1 |
|---|---|
| DateTime | 1 |
| Numeric | 7 |
| Categorical | 3 |
Currency Code has constant value "USD" | Constant |
Line Total is highly overall correlated with Total Unit Cost and 1 other fields | High correlation |
Total Unit Cost is highly overall correlated with Line Total and 1 other fields | High correlation |
Unit Price is highly overall correlated with Line Total and 1 other fields | High correlation |
Reproduction
| Analysis started | 2025-07-14 02:58:11.172602 |
|---|---|
| Analysis finished | 2025-07-14 02:58:31.994339 |
| Duration | 20.82 seconds |
| Software version | ydata-profiling vv4.16.1 |
| Download configuration | config.json |
Variables
OrderNumber
Text
| Distinct | 10684 |
|---|---|
| Distinct (%) | 16.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.7 MiB |
Length
| Max length | 12 |
|---|---|
| Median length | 12 |
| Mean length | 11.915855 |
| Min length | 11 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | SO - 000225 |
|---|---|
| 2nd row | SO - 0003378 |
| 3rd row | SO - 0005126 |
| 4th row | SO - 0005614 |
| 5th row | SO - 0005781 |
| Value | Count | Frequency (%) |
| so | 64104 | |
| 64104 | ||
| 0010430 | 6 | < 0.1% |
| 0006279 | 6 | < 0.1% |
| 0009903 | 6 | < 0.1% |
| 0009346 | 6 | < 0.1% |
| 0005126 | 6 | < 0.1% |
| 0005614 | 6 | < 0.1% |
| 0005781 | 6 | < 0.1% |
| 0010394 | 6 | < 0.1% |
| Other values (10676) | 64056 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 211134 | |
| 128208 | ||
| S | 64104 | 8.4% |
| O | 64104 | 8.4% |
| - | 64104 | 8.4% |
| 1 | 30138 | 3.9% |
| 2 | 25434 | 3.3% |
| 3 | 25434 | 3.3% |
| 4 | 25434 | 3.3% |
| 5 | 25428 | 3.3% |
| Other values (4) | 100332 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 443334 | |
| Space Separator | 128208 | 16.8% |
| Uppercase Letter | 128208 | 16.8% |
| Dash Punctuation | 64104 | 8.4% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 211134 | |
| 1 | 30138 | 6.8% |
| 2 | 25434 | 5.7% |
| 3 | 25434 | 5.7% |
| 4 | 25434 | 5.7% |
| 5 | 25428 | 5.7% |
| 6 | 25428 | 5.7% |
| 7 | 25338 | 5.7% |
| 8 | 24798 | 5.6% |
| 9 | 24768 | 5.6% |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 64104 | |
| O | 64104 |
Space Separator
| Value | Count | Frequency (%) |
| 128208 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 64104 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 635646 | |
| Latin | 128208 | 16.8% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 211134 | |
| 128208 | ||
| - | 64104 | 10.1% |
| 1 | 30138 | 4.7% |
| 2 | 25434 | 4.0% |
| 3 | 25434 | 4.0% |
| 4 | 25434 | 4.0% |
| 5 | 25428 | 4.0% |
| 6 | 25428 | 4.0% |
| 7 | 25338 | 4.0% |
| Other values (2) | 49566 | 7.8% |
Latin
| Value | Count | Frequency (%) |
| S | 64104 | |
| O | 64104 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 763854 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 211134 | |
| 128208 | ||
| S | 64104 | 8.4% |
| O | 64104 | 8.4% |
| - | 64104 | 8.4% |
| 1 | 30138 | 3.9% |
| 2 | 25434 | 3.3% |
| 3 | 25434 | 3.3% |
| 4 | 25434 | 3.3% |
| 5 | 25428 | 3.3% |
| Other values (4) | 100332 |
OrderDate
Date
| Distinct | 1520 |
|---|---|
| Distinct (%) | 2.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 500.9 KiB |
| Minimum | 2014-01-01 00:00:00 |
|---|---|
| Maximum | 2018-02-28 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Histogram with fixed size bins (bins=50)
Customer Name Index
Real number (ℝ)
| Distinct | 175 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 87.480064 |
| Minimum | 1 |
|---|---|
| Maximum | 175 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 500.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 9 |
| Q1 | 45 |
| median | 87 |
| Q3 | 130 |
| 95-th percentile | 165 |
| Maximum | 175 |
| Range | 174 |
| Interquartile range (IQR) | 85 |
Descriptive statistics
| Standard deviation | 49.884946 |
|---|---|
| Coefficient of variation (CV) | 0.57024359 |
| Kurtosis | -1.177726 |
| Mean | 87.480064 |
| Median Absolute Deviation (MAD) | 43 |
| Skewness | 0.0087141618 |
| Sum | 5607822 |
| Variance | 2488.5078 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 53 | 540 | 0.8% |
| 80 | 528 | 0.8% |
| 100 | 516 | 0.8% |
| 113 | 516 | 0.8% |
| 109 | 486 | 0.8% |
| 74 | 486 | 0.8% |
| 79 | 480 | 0.7% |
| 41 | 474 | 0.7% |
| 45 | 474 | 0.7% |
| 4 | 468 | 0.7% |
| Other values (165) | 59136 |
| Value | Count | Frequency (%) |
| 1 | 342 | |
| 2 | 366 | |
| 3 | 330 | |
| 4 | 468 | |
| 5 | 384 | |
| 6 | 342 | |
| 7 | 462 | |
| 8 | 222 | |
| 9 | 354 | |
| 10 | 324 |
| Value | Count | Frequency (%) |
| 175 | 300 | |
| 174 | 324 | |
| 173 | 390 | |
| 172 | 252 | |
| 171 | 330 | |
| 170 | 288 | |
| 169 | 312 | |
| 168 | 396 | |
| 167 | 306 | |
| 166 | 306 |
Channel
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.6 MiB |
| Wholesale | |
|---|---|
| Distributor | |
| Export |
Length
| Max length | 11 |
|---|---|
| Median length | 9 |
| Mean length | 9.1765256 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Wholesale |
|---|---|
| 2nd row | Distributor |
| 3rd row | Wholesale |
| 4th row | Export |
| 5th row | Wholesale |
Common Values
| Value | Count | Frequency (%) |
| Wholesale | 34596 | |
| Distributor | 19968 | |
| Export | 9540 | 14.9% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| wholesale | 34596 | |
| distributor | 19968 | |
| export | 9540 | 14.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| l | 69192 | |
| e | 69192 | |
| o | 64104 | |
| s | 54564 | |
| t | 49476 | |
| r | 49476 | |
| i | 39936 | |
| W | 34596 | 5.9% |
| h | 34596 | 5.9% |
| a | 34596 | 5.9% |
| Other values (6) | 88524 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 524148 | |
| Uppercase Letter | 64104 | 10.9% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| l | 69192 | |
| e | 69192 | |
| o | 64104 | |
| s | 54564 | |
| t | 49476 | |
| r | 49476 | |
| i | 39936 | |
| h | 34596 | |
| a | 34596 | |
| b | 19968 | 3.8% |
| Other values (3) | 39048 |
Uppercase Letter
| Value | Count | Frequency (%) |
| W | 34596 | |
| D | 19968 | |
| E | 9540 | 14.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 588252 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| l | 69192 | |
| e | 69192 | |
| o | 64104 | |
| s | 54564 | |
| t | 49476 | |
| r | 49476 | |
| i | 39936 | |
| W | 34596 | 5.9% |
| h | 34596 | 5.9% |
| a | 34596 | 5.9% |
| Other values (6) | 88524 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 588252 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| l | 69192 | |
| e | 69192 | |
| o | 64104 | |
| s | 54564 | |
| t | 49476 | |
| r | 49476 | |
| i | 39936 | |
| W | 34596 | 5.9% |
| h | 34596 | 5.9% |
| a | 34596 | 5.9% |
| Other values (6) | 88524 |
Currency Code
Categorical
Constant
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.2 MiB |
| USD |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | USD |
|---|---|
| 2nd row | USD |
| 3rd row | USD |
| 4th row | USD |
| 5th row | USD |
Common Values
| Value | Count | Frequency (%) |
| USD | 64104 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| usd | 64104 |
Most occurring characters
| Value | Count | Frequency (%) |
| U | 64104 | |
| S | 64104 | |
| D | 64104 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 192312 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| U | 64104 | |
| S | 64104 | |
| D | 64104 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 192312 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| U | 64104 | |
| S | 64104 | |
| D | 64104 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 192312 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| U | 64104 | |
| S | 64104 | |
| D | 64104 |
Warehouse Code
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.4 MiB |
| AXW291 | |
|---|---|
| GUT930 | |
| NXH382 | |
| FLR025 |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 6 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | AXW291 |
|---|---|
| 2nd row | AXW291 |
| 3rd row | AXW291 |
| 4th row | AXW291 |
| 5th row | AXW291 |
Common Values
| Value | Count | Frequency (%) |
| AXW291 | 30204 | |
| GUT930 | 14724 | |
| NXH382 | 12564 | |
| FLR025 | 6612 | 10.3% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| axw291 | 30204 | |
| gut930 | 14724 | |
| nxh382 | 12564 | |
| flr025 | 6612 | 10.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 49380 | |
| 9 | 44928 | |
| X | 42768 | |
| A | 30204 | 7.9% |
| W | 30204 | 7.9% |
| 1 | 30204 | 7.9% |
| 3 | 27288 | 7.1% |
| 0 | 21336 | 5.5% |
| U | 14724 | 3.8% |
| T | 14724 | 3.8% |
| Other values (8) | 78864 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 192312 | |
| Uppercase Letter | 192312 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| X | 42768 | |
| A | 30204 | |
| W | 30204 | |
| U | 14724 | 7.7% |
| T | 14724 | 7.7% |
| G | 14724 | 7.7% |
| N | 12564 | 6.5% |
| H | 12564 | 6.5% |
| F | 6612 | 3.4% |
| L | 6612 | 3.4% |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 49380 | |
| 9 | 44928 | |
| 1 | 30204 | |
| 3 | 27288 | |
| 0 | 21336 | |
| 8 | 12564 | 6.5% |
| 5 | 6612 | 3.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 192312 | |
| Latin | 192312 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| X | 42768 | |
| A | 30204 | |
| W | 30204 | |
| U | 14724 | 7.7% |
| T | 14724 | 7.7% |
| G | 14724 | 7.7% |
| N | 12564 | 6.5% |
| H | 12564 | 6.5% |
| F | 6612 | 3.4% |
| L | 6612 | 3.4% |
Common
| Value | Count | Frequency (%) |
| 2 | 49380 | |
| 9 | 44928 | |
| 1 | 30204 | |
| 3 | 27288 | |
| 0 | 21336 | |
| 8 | 12564 | 6.5% |
| 5 | 6612 | 3.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 384624 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 49380 | |
| 9 | 44928 | |
| X | 42768 | |
| A | 30204 | 7.9% |
| W | 30204 | 7.9% |
| 1 | 30204 | 7.9% |
| 3 | 27288 | 7.1% |
| 0 | 21336 | 5.5% |
| U | 14724 | 3.8% |
| T | 14724 | 3.8% |
| Other values (8) | 78864 |
Delivery Region Index
Real number (ℝ)
| Distinct | 993 |
|---|---|
| Distinct (%) | 1.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 495.08661 |
| Minimum | 1 |
|---|---|
| Maximum | 994 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 500.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 52 |
| Q1 | 247 |
| median | 493 |
| Q3 | 742 |
| 95-th percentile | 944 |
| Maximum | 994 |
| Range | 993 |
| Interquartile range (IQR) | 495 |
Descriptive statistics
| Standard deviation | 285.64589 |
|---|---|
| Coefficient of variation (CV) | 0.57696146 |
| Kurtosis | -1.1924371 |
| Mean | 495.08661 |
| Median Absolute Deviation (MAD) | 247 |
| Skewness | 0.015030778 |
| Sum | 31737032 |
| Variance | 81593.576 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 388 | 128 | 0.2% |
| 357 | 121 | 0.2% |
| 125 | 116 | 0.2% |
| 770 | 113 | 0.2% |
| 334 | 112 | 0.2% |
| 533 | 111 | 0.2% |
| 623 | 111 | 0.2% |
| 198 | 111 | 0.2% |
| 980 | 104 | 0.2% |
| 247 | 104 | 0.2% |
| Other values (983) | 62973 |
| Value | Count | Frequency (%) |
| 1 | 67 | |
| 2 | 78 | |
| 3 | 93 | |
| 4 | 79 | |
| 5 | 38 | |
| 6 | 51 | |
| 7 | 40 | |
| 8 | 58 | |
| 9 | 89 | |
| 10 | 44 |
| Value | Count | Frequency (%) |
| 994 | 54 | |
| 993 | 50 | |
| 992 | 72 | |
| 991 | 61 | |
| 990 | 70 | |
| 989 | 45 | |
| 988 | 48 | |
| 987 | 86 | |
| 986 | 63 | |
| 985 | 86 |
Product Description Index
Real number (ℝ)
| Distinct | 30 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 14.913141 |
| Minimum | 1 |
|---|---|
| Maximum | 30 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 500.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 6 |
| median | 15 |
| Q3 | 24 |
| 95-th percentile | 27 |
| Maximum | 30 |
| Range | 29 |
| Interquartile range (IQR) | 18 |
Descriptive statistics
| Standard deviation | 8.7870319 |
|---|---|
| Coefficient of variation (CV) | 0.58921403 |
| Kurtosis | -1.277439 |
| Mean | 14.913141 |
| Median Absolute Deviation (MAD) | 9 |
| Skewness | -0.0537098 |
| Sum | 955992 |
| Variance | 77.21193 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=30)
| Value | Count | Frequency (%) |
| 25 | 5994 | 9.4% |
| 26 | 5928 | 9.2% |
| 13 | 3948 | 6.2% |
| 14 | 3858 | 6.0% |
| 15 | 3696 | 5.8% |
| 5 | 3348 | 5.2% |
| 2 | 3162 | 4.9% |
| 1 | 2904 | 4.5% |
| 4 | 2886 | 4.5% |
| 3 | 2802 | 4.4% |
| Other values (20) | 25578 |
| Value | Count | Frequency (%) |
| 1 | 2904 | |
| 2 | 3162 | |
| 3 | 2802 | |
| 4 | 2886 | |
| 5 | 3348 | |
| 6 | 2118 | |
| 7 | 972 | 1.5% |
| 8 | 1002 | 1.6% |
| 9 | 810 | 1.3% |
| 10 | 870 | 1.4% |
| Value | Count | Frequency (%) |
| 30 | 1026 | 1.6% |
| 29 | 960 | 1.5% |
| 28 | 996 | 1.6% |
| 27 | 1080 | 1.7% |
| 26 | 5928 | |
| 25 | 5994 | |
| 24 | 822 | 1.3% |
| 23 | 996 | 1.6% |
| 22 | 942 | 1.5% |
| 21 | 996 | 1.6% |
Order Quantity
Real number (ℝ)
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.4416885 |
| Minimum | 5 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 500.9 KiB |
Quantile statistics
| Minimum | 5 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 6 |
| median | 8 |
| Q3 | 10 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 7 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 2.2762166 |
|---|---|
| Coefficient of variation (CV) | 0.26963997 |
| Kurtosis | -1.2298689 |
| Mean | 8.4416885 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.025681985 |
| Sum | 541146 |
| Variance | 5.1811621 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=8)
| Value | Count | Frequency (%) |
| 6 | 8298 | |
| 11 | 8286 | |
| 9 | 8280 | |
| 5 | 8160 | |
| 8 | 8142 | |
| 7 | 8076 | |
| 10 | 7560 | |
| 12 | 7302 |
| Value | Count | Frequency (%) |
| 5 | 8160 | |
| 6 | 8298 | |
| 7 | 8076 | |
| 8 | 8142 | |
| 9 | 8280 | |
| 10 | 7560 | |
| 11 | 8286 | |
| 12 | 7302 |
| Value | Count | Frequency (%) |
| 12 | 7302 | |
| 11 | 8286 | |
| 10 | 7560 | |
| 9 | 8280 | |
| 8 | 8142 | |
| 7 | 8076 | |
| 6 | 8298 | |
| 5 | 8160 |
Unit Price
Real number (ℝ)
High correlation
| Distinct | 664 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2284.3808 |
| Minimum | 167.5 |
|---|---|
| Maximum | 6566 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 500.9 KiB |
Quantile statistics
| Minimum | 167.5 |
|---|---|
| 5-th percentile | 214.4 |
| Q1 | 1031.8 |
| median | 1855.9 |
| Q3 | 3606.275 |
| 95-th percentile | 5835.7 |
| Maximum | 6566 |
| Range | 6398.5 |
| Interquartile range (IQR) | 2574.475 |
Descriptive statistics
| Standard deviation | 1663.5981 |
|---|---|
| Coefficient of variation (CV) | 0.72824905 |
| Kurtosis | -0.19177117 |
| Mean | 2284.3808 |
| Median Absolute Deviation (MAD) | 891.1 |
| Skewness | 0.84365299 |
| Sum | 1.4643795 × 108 |
| Variance | 2767558.8 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1051.9 | 690 | 1.1% |
| 1005 | 642 | 1.0% |
| 1125.6 | 630 | 1.0% |
| 1038.5 | 624 | 1.0% |
| 1078.7 | 618 | 1.0% |
| 1118.9 | 600 | 0.9% |
| 1058.6 | 588 | 0.9% |
| 1112.2 | 558 | 0.9% |
| 1065.3 | 546 | 0.9% |
| 1025.1 | 540 | 0.8% |
| Other values (654) | 58068 |
| Value | Count | Frequency (%) |
| 167.5 | 540 | |
| 174.2 | 396 | |
| 180.9 | 366 | |
| 187.6 | 348 | |
| 194.3 | 396 | |
| 201 | 408 | |
| 207.7 | 462 | |
| 214.4 | 432 | |
| 221.1 | 360 | |
| 227.8 | 522 |
| Value | Count | Frequency (%) |
| 6566 | 6 | < 0.1% |
| 6559.3 | 30 | |
| 6552.6 | 12 | < 0.1% |
| 6545.9 | 42 | |
| 6539.2 | 42 | |
| 6532.5 | 18 | |
| 6525.8 | 24 | |
| 6519.1 | 6 | < 0.1% |
| 6512.4 | 18 | |
| 6505.7 | 36 |
Line Total
Real number (ℝ)
High correlation
| Distinct | 2535 |
|---|---|
| Distinct (%) | 4.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 19280.683 |
| Minimum | 837.5 |
|---|---|
| Maximum | 78711.6 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 500.9 KiB |
Quantile statistics
| Minimum | 837.5 |
|---|---|
| 5-th percentile | 1768.8 |
| Q1 | 8019.9 |
| median | 14023.1 |
| Q3 | 27416.4 |
| 95-th percentile | 50544.8 |
| Maximum | 78711.6 |
| Range | 77874.1 |
| Interquartile range (IQR) | 19396.5 |
Descriptive statistics
| Standard deviation | 15429.603 |
|---|---|
| Coefficient of variation (CV) | 0.80026225 |
| Kurtosis | 1.1683817 |
| Mean | 19280.683 |
| Median Absolute Deviation (MAD) | 8046.7 |
| Skewness | 1.2250728 |
| Sum | 1.2359689 × 109 |
| Variance | 2.3807264 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 11055 | 180 | 0.3% |
| 2412 | 180 | 0.3% |
| 9648 | 174 | 0.3% |
| 1407 | 168 | 0.3% |
| 10854 | 168 | 0.3% |
| 9045 | 150 | 0.2% |
| 6753.6 | 150 | 0.2% |
| 1876 | 138 | 0.2% |
| 8576 | 138 | 0.2% |
| 10130.4 | 132 | 0.2% |
| Other values (2525) | 62526 |
| Value | Count | Frequency (%) |
| 837.5 | 120 | |
| 871 | 54 | |
| 904.5 | 60 | |
| 938 | 48 | 0.1% |
| 971.5 | 42 | 0.1% |
| 1005 | 120 | |
| 1038.5 | 102 | |
| 1045.2 | 30 | < 0.1% |
| 1072 | 48 | 0.1% |
| 1085.4 | 84 |
| Value | Count | Frequency (%) |
| 78711.6 | 18 | |
| 78550.8 | 6 | < 0.1% |
| 78470.4 | 12 | |
| 77746.8 | 6 | < 0.1% |
| 77505.6 | 6 | < 0.1% |
| 77425.2 | 24 | |
| 77344.8 | 6 | < 0.1% |
| 77023.2 | 6 | < 0.1% |
| 76621.2 | 6 | < 0.1% |
| 76540.8 | 12 |
Total Unit Cost
Real number (ℝ)
High correlation
| Distinct | 5581 |
|---|---|
| Distinct (%) | 8.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1432.0839 |
| Minimum | 68.675 |
|---|---|
| Maximum | 5498.556 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 500.9 KiB |
Quantile statistics
| Minimum | 68.675 |
|---|---|
| 5-th percentile | 130.65 |
| Q1 | 606.216 |
| median | 1084.4955 |
| Q3 | 2046.9338 |
| 95-th percentile | 3672.002 |
| Maximum | 5498.556 |
| Range | 5429.881 |
| Interquartile range (IQR) | 1440.7178 |
Descriptive statistics
| Standard deviation | 1107.7057 |
|---|---|
| Coefficient of variation (CV) | 0.7734922 |
| Kurtosis | 0.65378902 |
| Mean | 1432.0839 |
| Median Absolute Deviation (MAD) | 592.146 |
| Skewness | 1.0873259 |
| Sum | 91802306 |
| Variance | 1227012 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 502.5 | 66 | 0.1% |
| 933.98 | 66 | 0.1% |
| 743.7 | 66 | 0.1% |
| 728.96 | 60 | 0.1% |
| 95.676 | 60 | 0.1% |
| 726.012 | 60 | 0.1% |
| 569.5 | 54 | 0.1% |
| 825.44 | 54 | 0.1% |
| 563.805 | 54 | 0.1% |
| 621.76 | 54 | 0.1% |
| Other values (5571) | 63510 |
| Value | Count | Frequency (%) |
| 68.675 | 12 | < 0.1% |
| 69.68 | 12 | < 0.1% |
| 70.35 | 24 | |
| 72.025 | 18 | |
| 72.36 | 6 | < 0.1% |
| 73.164 | 12 | < 0.1% |
| 73.7 | 30 | |
| 74.169 | 18 | |
| 74.906 | 18 | |
| 75.04 | 18 |
| Value | Count | Frequency (%) |
| 5498.556 | 6 | |
| 5489.98 | 12 | |
| 5487.3 | 6 | |
| 5444.219 | 6 | |
| 5414.136 | 6 | |
| 5399.731 | 6 | |
| 5371.926 | 12 | |
| 5288.511 | 6 | |
| 5284.96 | 6 | |
| 5219.3 | 6 |
Interactions
Correlations
| Channel | Customer Name Index | Delivery Region Index | Line Total | Order Quantity | Product Description Index | Total Unit Cost | Unit Price | Warehouse Code | |
|---|---|---|---|---|---|---|---|---|---|
| Channel | 1.000 | 0.036 | 0.003 | 0.034 | 0.020 | 0.030 | 0.029 | 0.028 | 0.013 |
| Customer Name Index | 0.036 | 1.000 | -0.003 | -0.014 | 0.008 | -0.035 | -0.016 | -0.019 | 0.033 |
| Delivery Region Index | 0.003 | -0.003 | 1.000 | 0.004 | 0.001 | -0.003 | 0.003 | 0.004 | 0.010 |
| Line Total | 0.034 | -0.014 | 0.004 | 1.000 | 0.322 | -0.010 | 0.901 | 0.934 | 0.028 |
| Order Quantity | 0.020 | 0.008 | 0.001 | 0.322 | 1.000 | -0.002 | -0.007 | 0.000 | 0.018 |
| Product Description Index | 0.030 | -0.035 | -0.003 | -0.010 | -0.002 | 1.000 | -0.009 | -0.005 | 0.035 |
| Total Unit Cost | 0.029 | -0.016 | 0.003 | 0.901 | -0.007 | -0.009 | 1.000 | 0.954 | 0.029 |
| Unit Price | 0.028 | -0.019 | 0.004 | 0.934 | 0.000 | -0.005 | 0.954 | 1.000 | 0.032 |
| Warehouse Code | 0.013 | 0.033 | 0.010 | 0.028 | 0.018 | 0.035 | 0.029 | 0.032 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
Sample
| OrderNumber | OrderDate | Customer Name Index | Channel | Currency Code | Warehouse Code | Delivery Region Index | Product Description Index | Order Quantity | Unit Price | Line Total | Total Unit Cost | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | SO - 000225 | 2014-01-01 | 126 | Wholesale | USD | AXW291 | 364 | 27 | 6 | 2499.1 | 14994.6 | 1824.343 |
| 1 | SO - 0003378 | 2014-01-01 | 96 | Distributor | USD | AXW291 | 488 | 20 | 11 | 2351.7 | 25868.7 | 1269.918 |
| 2 | SO - 0005126 | 2014-01-01 | 8 | Wholesale | USD | AXW291 | 155 | 26 | 6 | 978.2 | 5869.2 | 684.740 |
| 3 | SO - 0005614 | 2014-01-01 | 42 | Export | USD | AXW291 | 473 | 7 | 7 | 2338.3 | 16368.1 | 1028.852 |
| 4 | SO - 0005781 | 2014-01-01 | 73 | Wholesale | USD | AXW291 | 256 | 8 | 8 | 2291.4 | 18331.2 | 1260.270 |
| 5 | SO - 0010394 | 2014-01-01 | 138 | Export | USD | NXH382 | 626 | 23 | 11 | 5219.3 | 57412.3 | 4332.019 |
| 6 | SO - 0008865 | 2014-01-01 | 53 | Wholesale | USD | GUT930 | 540 | 1 | 7 | 2874.3 | 20120.1 | 1667.094 |
| 7 | SO - 0009909 | 2014-01-01 | 45 | Wholesale | USD | AXW291 | 156 | 25 | 10 | 1045.2 | 10452.0 | 679.380 |
| 8 | SO - 0001912 | 2014-01-01 | 85 | Wholesale | USD | AXW291 | 934 | 13 | 5 | 3852.5 | 19262.5 | 2966.425 |
| 9 | SO - 0002683 | 2014-01-01 | 125 | Export | USD | AXW291 | 652 | 14 | 12 | 2914.5 | 34974.0 | 1311.525 |
| OrderNumber | OrderDate | Customer Name Index | Channel | Currency Code | Warehouse Code | Delivery Region Index | Product Description Index | Order Quantity | Unit Price | Line Total | Total Unit Cost | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 64094 | SO - 0002200 | 2018-02-28 | 75 | Distributor | USD | FLR025 | 437 | 13 | 9 | 3819.0 | 34371.0 | 1565.790 |
| 64095 | SO - 0002463 | 2018-02-28 | 34 | Export | USD | FLR025 | 504 | 12 | 11 | 6378.4 | 70162.4 | 3252.984 |
| 64096 | SO - 0004303 | 2018-02-28 | 156 | Wholesale | USD | NXH382 | 268 | 21 | 8 | 891.1 | 7128.8 | 507.927 |
| 64097 | SO - 0006289 | 2018-02-28 | 131 | Wholesale | USD | FLR025 | 30 | 1 | 10 | 5138.9 | 51389.0 | 4162.509 |
| 64098 | SO - 0007372 | 2018-02-28 | 154 | Distributor | USD | AXW291 | 784 | 5 | 10 | 5266.2 | 52662.0 | 3528.354 |
| 64099 | SO - 0007573 | 2018-02-28 | 74 | Wholesale | USD | AXW291 | 825 | 26 | 12 | 1815.7 | 21788.4 | 980.478 |
| 64100 | SO - 0007706 | 2018-02-28 | 51 | Export | USD | NXH382 | 444 | 21 | 6 | 864.3 | 5185.8 | 579.081 |
| 64101 | SO - 0007718 | 2018-02-28 | 136 | Distributor | USD | AXW291 | 312 | 13 | 11 | 3953.0 | 43483.0 | 2648.510 |
| 64102 | SO - 0008084 | 2018-02-28 | 158 | Distributor | USD | AXW291 | 737 | 20 | 7 | 3959.7 | 27717.9 | 2930.178 |
| 64103 | SO - 0008654 | 2018-02-28 | 22 | Distributor | USD | AXW291 | 807 | 15 | 8 | 998.3 | 7986.4 | 848.555 |